<?php

include 'FuncionarioController.php';

class SiteController extends Controller
{
	public $layout = '//layouts/column2';
	
	/**
	 * Declares class-based actions.
	 */
	public function actions()
	{
		return array(
				// captcha action renders the CAPTCHA image displayed on the contact page
				'captcha'=>array(
						'class'=>'CCaptchaAction',
						'backColor'=>0xFFFFFF,
				),
				// page action renders "static" pages stored under 'protected/views/site/pages'
				// They can be accessed via: index.php?r=site/page&view=FileName
				'page'=>array(
						'class'=>'CViewAction',
				),
		);
	}

	private function initData() {
	
		$this->initDatabase();
		
  		$this->initCaracteristica();

 		$this->initPerguntas();

  		$this->initClasses();

 		$this->initFuncionarios();

  		$this->initPerguntasClasses();

  		$this->initClassesCaracteristicas();

 		Periodo::closePeriodos();

	}

	private function initDatabase() {
		$query = file_get_contents(YiiBase::getPathOfAlias('webroot').'/protected/data/tabelas.sql');
		//try {
		$transaction=Yii::app()->db->beginTransaction();
		try
		{
			Yii::app()->db->createCommand($query)->execute();
			//.... other SQL executions
			$transaction->commit();
		}
		catch(Exception $e) // an exception is raised if a query fails
		{
			$transaction->rollback();
		}
	}
	
	private function initCaracteristica() {
		$caracs = Caracteristica::model()->findAll();
		if(empty($caracs)) {
			Caracteristica::addCaracteristicas(); //utilizado no primeiro uso
		}
	}

	private function initPerguntas() {
		$pergunts = Pergunta::model()->findAll();

		if(empty($pergunts)) {
			Pergunta::addPerguntas();
		}
	}

	private function initClasses() {
		$class = Classe::model()->findAll();
		if(empty($class)) {
			Classe::addClasses();
		}
	}

	private function initFuncionarios() {
		$funcionario = Funcionario::model()->findAll();
		if(empty($funcionario)) {
			Funcionario::addAdmin();
		}
	}

	private function initClassesCaracteristicas () {
		$classCaracs = ClasseHasCaracteristica::model()->findAll();
		if(empty($classCaracs)) {
			ClasseHasCaracteristica::addClassesCaracteristicas();
		}
	}

	private function initPerguntasClasses() {
		$class = ClasseHasPergunta::model()->findAll();
		if(empty($class)) {
			ClasseHasPergunta::addRelationsPart1();
			ClasseHasPergunta::addRelationsPart2();
		}
	}

	/**
	 * This is the default 'index' action that is invoked
	 * when an action is not explicitly requested by users.
	 */
	public function actionIndex()
	{
		$this->initData();
		if(Yii::app()->user->isGuest) {
			$this->actionLogin();

		} else {
			
			$model = FuncionarioController::loadModel(Yii::app()->session['idAtual']);
			$this->render('index',array(
				'model' => $model,
					
		));
			//$this->initPeriodo();
		}
	}

	//aparentemente nao utilizado até segunda ordem

	public function initPeriodo() {
		$user = TblUser::model()->findByAttributes(array('username'=>Yii::app()->user->name));
		$funcionario = Funcionario::model()->findByAttributes(array('id'=>$user->funcionario_id));
		$periodos = Periodo::model()->findAllByAttributes(array('polo_id'=>$funcionario->polo_id));
		if (empty($periodos)) {
			Periodo::addPeriodo($funcionario->polo_id);
		} else {
			$element = end($periodos);
			reset($periodos);
			if(semPeriodosAbertos($funcionario->polo_id) && Periodo::subtractDate(date('d/m/Y'), $element->fim_inscricao) > 90) {
				Periodo::addPeriodo($funcionario->polo_id);
			}
		}
	}


	public function createTurmasTable($model) {
		
	}
	

	/**
	 * This is the action to handle external exceptions.
	 */
	public function actionError()
	{
		if($error=Yii::app()->errorHandler->error)
		{
			if(Yii::app()->request->isAjaxRequest)
				echo $error['message'];
			else
				$this->render('error', $error);
		}
	}

	/**
	 * Displays the contact page
	 */
	public function actionContact()
	{
		$model=new ContactForm;
		if(isset($_POST['ContactForm']))
		{
			$model->attributes=$_POST['ContactForm'];
			if($model->validate())
			{
				$name='=?UTF-8?B?'.base64_encode($model->name).'?=';
				$subject='=?UTF-8?B?'.base64_encode($model->subject).'?=';
				$headers="From: $name <{$model->email}>\r\n".
						"Reply-To: {$model->email}\r\n".
						"MIME-Version: 1.0\r\n".
						"Content-Type: text/plain; charset=UTF-8";

				mail(Yii::app()->params['adminEmail'],$subject,$model->body,$headers);
				Yii::app()->user->setFlash('contact','Thank you for contacting us. We will respond to you as soon as possible.');
				$this->refresh();
			}
		}
		$this->render('contact',array('model'=>$model));
	}

	public function actionAluno()
	{
		$model= new Aluno;
		$this->redirect(Yii::app()->homeUrl);
	}

	/**
	 * Displays the login page
	 */
	public function actionLogin()
	{
		$model=new MyLoginForm;

		// if it is ajax validation request
		if(isset($_POST['ajax']) && $_POST['ajax']==='new-form')
		{
			echo CActiveForm::validate($model);
			Yii::app()->end();
		}

		// collect user input data
		if(isset($_POST['MyLoginForm']))
		{
			$model->attributes=$_POST['MyLoginForm'];
			// validate user input and redirect to the previous page if valid
			if($model->validate() && $model->login()) {
				$user = TblUser::model()->findByAttributes(array('username'=>Yii::app()->user->name));
				$funcionario = Funcionario::model()->findByAttributes(array('id'=>$user->funcionario_id));
				Yii::app()->session['polo_id'] = $funcionario->polo_id;
				Yii::app()->session['idAtual'] = $funcionario->id;
				Yii::app()->session['user_type'] = $funcionario->tipo;
				Yii::app() ->session['nome'] = Pessoa::model()->findByAttributes(array('id'=>$funcionario->pessoa_id))->nome;

				//                            $this->polo_id = $funcionario->polo_id;;
				//
				//                            $this->idAtual = $user->funcionario_id;
				$this->redirect(Yii::app()->user->returnUrl);
			} else {
				Dialog::Message('Falha no Login', "Usuário ou Senha Incorretos");
			}
		}
		// display the login form
		$this->render('login',array('model'=>$model));
	}

	/**
	 * Logs out the current user and redirect to homepage.
	 */
	public function actionLogout()
	{
		Yii::app()->user->logout();
		$this->redirect(Yii::app()->homeUrl);
	}

}